package com.nursery.student.entity;

import java.util.ArrayList;
import java.util.List;

public class StudentInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public StudentInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * t_student_info null
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCardNoIsNull() {
            addCriterion("CARD_NO is null");
            return (Criteria) this;
        }

        public Criteria andCardNoIsNotNull() {
            addCriterion("CARD_NO is not null");
            return (Criteria) this;
        }

        public Criteria andCardNoEqualTo(String value) {
            addCriterion("CARD_NO =", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotEqualTo(String value) {
            addCriterion("CARD_NO <>", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoGreaterThan(String value) {
            addCriterion("CARD_NO >", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_NO >=", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLessThan(String value) {
            addCriterion("CARD_NO <", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLessThanOrEqualTo(String value) {
            addCriterion("CARD_NO <=", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoLike(String value) {
            addCriterion("CARD_NO like", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotLike(String value) {
            addCriterion("CARD_NO not like", value, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoIn(List<String> values) {
            addCriterion("CARD_NO in", values, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotIn(List<String> values) {
            addCriterion("CARD_NO not in", values, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoBetween(String value1, String value2) {
            addCriterion("CARD_NO between", value1, value2, "cardNo");
            return (Criteria) this;
        }

        public Criteria andCardNoNotBetween(String value1, String value2) {
            addCriterion("CARD_NO not between", value1, value2, "cardNo");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("PASSWORD =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("PASSWORD <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("PASSWORD >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("PASSWORD >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("PASSWORD <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("PASSWORD <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("PASSWORD like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("PASSWORD not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("PASSWORD in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("PASSWORD not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("PASSWORD between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("PASSWORD not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andStuNameIsNull() {
            addCriterion("STU_NAME is null");
            return (Criteria) this;
        }

        public Criteria andStuNameIsNotNull() {
            addCriterion("STU_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andStuNameEqualTo(String value) {
            addCriterion("STU_NAME =", value, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameNotEqualTo(String value) {
            addCriterion("STU_NAME <>", value, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameGreaterThan(String value) {
            addCriterion("STU_NAME >", value, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameGreaterThanOrEqualTo(String value) {
            addCriterion("STU_NAME >=", value, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameLessThan(String value) {
            addCriterion("STU_NAME <", value, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameLessThanOrEqualTo(String value) {
            addCriterion("STU_NAME <=", value, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameLike(String value) {
            addCriterion("STU_NAME like", value, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameNotLike(String value) {
            addCriterion("STU_NAME not like", value, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameIn(List<String> values) {
            addCriterion("STU_NAME in", values, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameNotIn(List<String> values) {
            addCriterion("STU_NAME not in", values, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameBetween(String value1, String value2) {
            addCriterion("STU_NAME between", value1, value2, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuNameNotBetween(String value1, String value2) {
            addCriterion("STU_NAME not between", value1, value2, "stuName");
            return (Criteria) this;
        }

        public Criteria andStuSexIsNull() {
            addCriterion("STU_SEX is null");
            return (Criteria) this;
        }

        public Criteria andStuSexIsNotNull() {
            addCriterion("STU_SEX is not null");
            return (Criteria) this;
        }

        public Criteria andStuSexEqualTo(String value) {
            addCriterion("STU_SEX =", value, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexNotEqualTo(String value) {
            addCriterion("STU_SEX <>", value, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexGreaterThan(String value) {
            addCriterion("STU_SEX >", value, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexGreaterThanOrEqualTo(String value) {
            addCriterion("STU_SEX >=", value, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexLessThan(String value) {
            addCriterion("STU_SEX <", value, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexLessThanOrEqualTo(String value) {
            addCriterion("STU_SEX <=", value, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexLike(String value) {
            addCriterion("STU_SEX like", value, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexNotLike(String value) {
            addCriterion("STU_SEX not like", value, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexIn(List<String> values) {
            addCriterion("STU_SEX in", values, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexNotIn(List<String> values) {
            addCriterion("STU_SEX not in", values, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexBetween(String value1, String value2) {
            addCriterion("STU_SEX between", value1, value2, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuSexNotBetween(String value1, String value2) {
            addCriterion("STU_SEX not between", value1, value2, "stuSex");
            return (Criteria) this;
        }

        public Criteria andStuBirthIsNull() {
            addCriterion("STU_BIRTH is null");
            return (Criteria) this;
        }

        public Criteria andStuBirthIsNotNull() {
            addCriterion("STU_BIRTH is not null");
            return (Criteria) this;
        }

        public Criteria andStuBirthEqualTo(String value) {
            addCriterion("STU_BIRTH =", value, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthNotEqualTo(String value) {
            addCriterion("STU_BIRTH <>", value, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthGreaterThan(String value) {
            addCriterion("STU_BIRTH >", value, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthGreaterThanOrEqualTo(String value) {
            addCriterion("STU_BIRTH >=", value, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthLessThan(String value) {
            addCriterion("STU_BIRTH <", value, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthLessThanOrEqualTo(String value) {
            addCriterion("STU_BIRTH <=", value, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthLike(String value) {
            addCriterion("STU_BIRTH like", value, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthNotLike(String value) {
            addCriterion("STU_BIRTH not like", value, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthIn(List<String> values) {
            addCriterion("STU_BIRTH in", values, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthNotIn(List<String> values) {
            addCriterion("STU_BIRTH not in", values, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthBetween(String value1, String value2) {
            addCriterion("STU_BIRTH between", value1, value2, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andStuBirthNotBetween(String value1, String value2) {
            addCriterion("STU_BIRTH not between", value1, value2, "stuBirth");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andCensusAddrIsNull() {
            addCriterion("CENSUS_ADDR is null");
            return (Criteria) this;
        }

        public Criteria andCensusAddrIsNotNull() {
            addCriterion("CENSUS_ADDR is not null");
            return (Criteria) this;
        }

        public Criteria andCensusAddrEqualTo(String value) {
            addCriterion("CENSUS_ADDR =", value, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrNotEqualTo(String value) {
            addCriterion("CENSUS_ADDR <>", value, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrGreaterThan(String value) {
            addCriterion("CENSUS_ADDR >", value, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrGreaterThanOrEqualTo(String value) {
            addCriterion("CENSUS_ADDR >=", value, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrLessThan(String value) {
            addCriterion("CENSUS_ADDR <", value, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrLessThanOrEqualTo(String value) {
            addCriterion("CENSUS_ADDR <=", value, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrLike(String value) {
            addCriterion("CENSUS_ADDR like", value, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrNotLike(String value) {
            addCriterion("CENSUS_ADDR not like", value, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrIn(List<String> values) {
            addCriterion("CENSUS_ADDR in", values, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrNotIn(List<String> values) {
            addCriterion("CENSUS_ADDR not in", values, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrBetween(String value1, String value2) {
            addCriterion("CENSUS_ADDR between", value1, value2, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andCensusAddrNotBetween(String value1, String value2) {
            addCriterion("CENSUS_ADDR not between", value1, value2, "censusAddr");
            return (Criteria) this;
        }

        public Criteria andHouseMasterIsNull() {
            addCriterion("HOUSE_MASTER is null");
            return (Criteria) this;
        }

        public Criteria andHouseMasterIsNotNull() {
            addCriterion("HOUSE_MASTER is not null");
            return (Criteria) this;
        }

        public Criteria andHouseMasterEqualTo(String value) {
            addCriterion("HOUSE_MASTER =", value, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterNotEqualTo(String value) {
            addCriterion("HOUSE_MASTER <>", value, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterGreaterThan(String value) {
            addCriterion("HOUSE_MASTER >", value, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterGreaterThanOrEqualTo(String value) {
            addCriterion("HOUSE_MASTER >=", value, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterLessThan(String value) {
            addCriterion("HOUSE_MASTER <", value, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterLessThanOrEqualTo(String value) {
            addCriterion("HOUSE_MASTER <=", value, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterLike(String value) {
            addCriterion("HOUSE_MASTER like", value, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterNotLike(String value) {
            addCriterion("HOUSE_MASTER not like", value, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterIn(List<String> values) {
            addCriterion("HOUSE_MASTER in", values, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterNotIn(List<String> values) {
            addCriterion("HOUSE_MASTER not in", values, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterBetween(String value1, String value2) {
            addCriterion("HOUSE_MASTER between", value1, value2, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterNotBetween(String value1, String value2) {
            addCriterion("HOUSE_MASTER not between", value1, value2, "houseMaster");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationIsNull() {
            addCriterion("HOUSE_MASTER_RELATION is null");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationIsNotNull() {
            addCriterion("HOUSE_MASTER_RELATION is not null");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationEqualTo(String value) {
            addCriterion("HOUSE_MASTER_RELATION =", value, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationNotEqualTo(String value) {
            addCriterion("HOUSE_MASTER_RELATION <>", value, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationGreaterThan(String value) {
            addCriterion("HOUSE_MASTER_RELATION >", value, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationGreaterThanOrEqualTo(String value) {
            addCriterion("HOUSE_MASTER_RELATION >=", value, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationLessThan(String value) {
            addCriterion("HOUSE_MASTER_RELATION <", value, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationLessThanOrEqualTo(String value) {
            addCriterion("HOUSE_MASTER_RELATION <=", value, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationLike(String value) {
            addCriterion("HOUSE_MASTER_RELATION like", value, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationNotLike(String value) {
            addCriterion("HOUSE_MASTER_RELATION not like", value, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationIn(List<String> values) {
            addCriterion("HOUSE_MASTER_RELATION in", values, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationNotIn(List<String> values) {
            addCriterion("HOUSE_MASTER_RELATION not in", values, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationBetween(String value1, String value2) {
            addCriterion("HOUSE_MASTER_RELATION between", value1, value2, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andHouseMasterRelationNotBetween(String value1, String value2) {
            addCriterion("HOUSE_MASTER_RELATION not between", value1, value2, "houseMasterRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyNameIsNull() {
            addCriterion("PROPERTY_NAME is null");
            return (Criteria) this;
        }

        public Criteria andPropertyNameIsNotNull() {
            addCriterion("PROPERTY_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andPropertyNameEqualTo(String value) {
            addCriterion("PROPERTY_NAME =", value, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameNotEqualTo(String value) {
            addCriterion("PROPERTY_NAME <>", value, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameGreaterThan(String value) {
            addCriterion("PROPERTY_NAME >", value, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameGreaterThanOrEqualTo(String value) {
            addCriterion("PROPERTY_NAME >=", value, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameLessThan(String value) {
            addCriterion("PROPERTY_NAME <", value, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameLessThanOrEqualTo(String value) {
            addCriterion("PROPERTY_NAME <=", value, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameLike(String value) {
            addCriterion("PROPERTY_NAME like", value, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameNotLike(String value) {
            addCriterion("PROPERTY_NAME not like", value, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameIn(List<String> values) {
            addCriterion("PROPERTY_NAME in", values, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameNotIn(List<String> values) {
            addCriterion("PROPERTY_NAME not in", values, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameBetween(String value1, String value2) {
            addCriterion("PROPERTY_NAME between", value1, value2, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyNameNotBetween(String value1, String value2) {
            addCriterion("PROPERTY_NAME not between", value1, value2, "propertyName");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationIsNull() {
            addCriterion("PROPERTY_RELATION is null");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationIsNotNull() {
            addCriterion("PROPERTY_RELATION is not null");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationEqualTo(String value) {
            addCriterion("PROPERTY_RELATION =", value, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationNotEqualTo(String value) {
            addCriterion("PROPERTY_RELATION <>", value, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationGreaterThan(String value) {
            addCriterion("PROPERTY_RELATION >", value, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationGreaterThanOrEqualTo(String value) {
            addCriterion("PROPERTY_RELATION >=", value, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationLessThan(String value) {
            addCriterion("PROPERTY_RELATION <", value, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationLessThanOrEqualTo(String value) {
            addCriterion("PROPERTY_RELATION <=", value, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationLike(String value) {
            addCriterion("PROPERTY_RELATION like", value, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationNotLike(String value) {
            addCriterion("PROPERTY_RELATION not like", value, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationIn(List<String> values) {
            addCriterion("PROPERTY_RELATION in", values, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationNotIn(List<String> values) {
            addCriterion("PROPERTY_RELATION not in", values, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationBetween(String value1, String value2) {
            addCriterion("PROPERTY_RELATION between", value1, value2, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andPropertyRelationNotBetween(String value1, String value2) {
            addCriterion("PROPERTY_RELATION not between", value1, value2, "propertyRelation");
            return (Criteria) this;
        }

        public Criteria andCertificateNoIsNull() {
            addCriterion("CERTIFICATE_NO is null");
            return (Criteria) this;
        }

        public Criteria andCertificateNoIsNotNull() {
            addCriterion("CERTIFICATE_NO is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateNoEqualTo(String value) {
            addCriterion("CERTIFICATE_NO =", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoNotEqualTo(String value) {
            addCriterion("CERTIFICATE_NO <>", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoGreaterThan(String value) {
            addCriterion("CERTIFICATE_NO >", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoGreaterThanOrEqualTo(String value) {
            addCriterion("CERTIFICATE_NO >=", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoLessThan(String value) {
            addCriterion("CERTIFICATE_NO <", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoLessThanOrEqualTo(String value) {
            addCriterion("CERTIFICATE_NO <=", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoLike(String value) {
            addCriterion("CERTIFICATE_NO like", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoNotLike(String value) {
            addCriterion("CERTIFICATE_NO not like", value, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoIn(List<String> values) {
            addCriterion("CERTIFICATE_NO in", values, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoNotIn(List<String> values) {
            addCriterion("CERTIFICATE_NO not in", values, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoBetween(String value1, String value2) {
            addCriterion("CERTIFICATE_NO between", value1, value2, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andCertificateNoNotBetween(String value1, String value2) {
            addCriterion("CERTIFICATE_NO not between", value1, value2, "certificateNo");
            return (Criteria) this;
        }

        public Criteria andGuarName1IsNull() {
            addCriterion("GUAR_NAME_1 is null");
            return (Criteria) this;
        }

        public Criteria andGuarName1IsNotNull() {
            addCriterion("GUAR_NAME_1 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarName1EqualTo(String value) {
            addCriterion("GUAR_NAME_1 =", value, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1NotEqualTo(String value) {
            addCriterion("GUAR_NAME_1 <>", value, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1GreaterThan(String value) {
            addCriterion("GUAR_NAME_1 >", value, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_NAME_1 >=", value, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1LessThan(String value) {
            addCriterion("GUAR_NAME_1 <", value, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1LessThanOrEqualTo(String value) {
            addCriterion("GUAR_NAME_1 <=", value, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1Like(String value) {
            addCriterion("GUAR_NAME_1 like", value, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1NotLike(String value) {
            addCriterion("GUAR_NAME_1 not like", value, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1In(List<String> values) {
            addCriterion("GUAR_NAME_1 in", values, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1NotIn(List<String> values) {
            addCriterion("GUAR_NAME_1 not in", values, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1Between(String value1, String value2) {
            addCriterion("GUAR_NAME_1 between", value1, value2, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarName1NotBetween(String value1, String value2) {
            addCriterion("GUAR_NAME_1 not between", value1, value2, "guarName1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1IsNull() {
            addCriterion("GUAR_RELATION_1 is null");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1IsNotNull() {
            addCriterion("GUAR_RELATION_1 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1EqualTo(String value) {
            addCriterion("GUAR_RELATION_1 =", value, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1NotEqualTo(String value) {
            addCriterion("GUAR_RELATION_1 <>", value, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1GreaterThan(String value) {
            addCriterion("GUAR_RELATION_1 >", value, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_RELATION_1 >=", value, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1LessThan(String value) {
            addCriterion("GUAR_RELATION_1 <", value, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1LessThanOrEqualTo(String value) {
            addCriterion("GUAR_RELATION_1 <=", value, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1Like(String value) {
            addCriterion("GUAR_RELATION_1 like", value, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1NotLike(String value) {
            addCriterion("GUAR_RELATION_1 not like", value, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1In(List<String> values) {
            addCriterion("GUAR_RELATION_1 in", values, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1NotIn(List<String> values) {
            addCriterion("GUAR_RELATION_1 not in", values, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1Between(String value1, String value2) {
            addCriterion("GUAR_RELATION_1 between", value1, value2, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarRelation1NotBetween(String value1, String value2) {
            addCriterion("GUAR_RELATION_1 not between", value1, value2, "guarRelation1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1IsNull() {
            addCriterion("GUAR_CARD_NO_1 is null");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1IsNotNull() {
            addCriterion("GUAR_CARD_NO_1 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1EqualTo(String value) {
            addCriterion("GUAR_CARD_NO_1 =", value, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1NotEqualTo(String value) {
            addCriterion("GUAR_CARD_NO_1 <>", value, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1GreaterThan(String value) {
            addCriterion("GUAR_CARD_NO_1 >", value, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_CARD_NO_1 >=", value, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1LessThan(String value) {
            addCriterion("GUAR_CARD_NO_1 <", value, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1LessThanOrEqualTo(String value) {
            addCriterion("GUAR_CARD_NO_1 <=", value, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1Like(String value) {
            addCriterion("GUAR_CARD_NO_1 like", value, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1NotLike(String value) {
            addCriterion("GUAR_CARD_NO_1 not like", value, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1In(List<String> values) {
            addCriterion("GUAR_CARD_NO_1 in", values, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1NotIn(List<String> values) {
            addCriterion("GUAR_CARD_NO_1 not in", values, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1Between(String value1, String value2) {
            addCriterion("GUAR_CARD_NO_1 between", value1, value2, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo1NotBetween(String value1, String value2) {
            addCriterion("GUAR_CARD_NO_1 not between", value1, value2, "guarCardNo1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1IsNull() {
            addCriterion("GUAR_PHONE_1 is null");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1IsNotNull() {
            addCriterion("GUAR_PHONE_1 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1EqualTo(String value) {
            addCriterion("GUAR_PHONE_1 =", value, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1NotEqualTo(String value) {
            addCriterion("GUAR_PHONE_1 <>", value, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1GreaterThan(String value) {
            addCriterion("GUAR_PHONE_1 >", value, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_PHONE_1 >=", value, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1LessThan(String value) {
            addCriterion("GUAR_PHONE_1 <", value, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1LessThanOrEqualTo(String value) {
            addCriterion("GUAR_PHONE_1 <=", value, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1Like(String value) {
            addCriterion("GUAR_PHONE_1 like", value, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1NotLike(String value) {
            addCriterion("GUAR_PHONE_1 not like", value, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1In(List<String> values) {
            addCriterion("GUAR_PHONE_1 in", values, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1NotIn(List<String> values) {
            addCriterion("GUAR_PHONE_1 not in", values, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1Between(String value1, String value2) {
            addCriterion("GUAR_PHONE_1 between", value1, value2, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarPhone1NotBetween(String value1, String value2) {
            addCriterion("GUAR_PHONE_1 not between", value1, value2, "guarPhone1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1IsNull() {
            addCriterion("GUAR_COMPANY_1 is null");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1IsNotNull() {
            addCriterion("GUAR_COMPANY_1 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1EqualTo(String value) {
            addCriterion("GUAR_COMPANY_1 =", value, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1NotEqualTo(String value) {
            addCriterion("GUAR_COMPANY_1 <>", value, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1GreaterThan(String value) {
            addCriterion("GUAR_COMPANY_1 >", value, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_COMPANY_1 >=", value, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1LessThan(String value) {
            addCriterion("GUAR_COMPANY_1 <", value, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1LessThanOrEqualTo(String value) {
            addCriterion("GUAR_COMPANY_1 <=", value, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1Like(String value) {
            addCriterion("GUAR_COMPANY_1 like", value, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1NotLike(String value) {
            addCriterion("GUAR_COMPANY_1 not like", value, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1In(List<String> values) {
            addCriterion("GUAR_COMPANY_1 in", values, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1NotIn(List<String> values) {
            addCriterion("GUAR_COMPANY_1 not in", values, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1Between(String value1, String value2) {
            addCriterion("GUAR_COMPANY_1 between", value1, value2, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarCompany1NotBetween(String value1, String value2) {
            addCriterion("GUAR_COMPANY_1 not between", value1, value2, "guarCompany1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1IsNull() {
            addCriterion("GUAR_JOB_1 is null");
            return (Criteria) this;
        }

        public Criteria andGuarJob1IsNotNull() {
            addCriterion("GUAR_JOB_1 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarJob1EqualTo(String value) {
            addCriterion("GUAR_JOB_1 =", value, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1NotEqualTo(String value) {
            addCriterion("GUAR_JOB_1 <>", value, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1GreaterThan(String value) {
            addCriterion("GUAR_JOB_1 >", value, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_JOB_1 >=", value, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1LessThan(String value) {
            addCriterion("GUAR_JOB_1 <", value, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1LessThanOrEqualTo(String value) {
            addCriterion("GUAR_JOB_1 <=", value, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1Like(String value) {
            addCriterion("GUAR_JOB_1 like", value, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1NotLike(String value) {
            addCriterion("GUAR_JOB_1 not like", value, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1In(List<String> values) {
            addCriterion("GUAR_JOB_1 in", values, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1NotIn(List<String> values) {
            addCriterion("GUAR_JOB_1 not in", values, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1Between(String value1, String value2) {
            addCriterion("GUAR_JOB_1 between", value1, value2, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarJob1NotBetween(String value1, String value2) {
            addCriterion("GUAR_JOB_1 not between", value1, value2, "guarJob1");
            return (Criteria) this;
        }

        public Criteria andGuarName2IsNull() {
            addCriterion("GUAR_NAME_2 is null");
            return (Criteria) this;
        }

        public Criteria andGuarName2IsNotNull() {
            addCriterion("GUAR_NAME_2 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarName2EqualTo(String value) {
            addCriterion("GUAR_NAME_2 =", value, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2NotEqualTo(String value) {
            addCriterion("GUAR_NAME_2 <>", value, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2GreaterThan(String value) {
            addCriterion("GUAR_NAME_2 >", value, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_NAME_2 >=", value, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2LessThan(String value) {
            addCriterion("GUAR_NAME_2 <", value, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2LessThanOrEqualTo(String value) {
            addCriterion("GUAR_NAME_2 <=", value, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2Like(String value) {
            addCriterion("GUAR_NAME_2 like", value, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2NotLike(String value) {
            addCriterion("GUAR_NAME_2 not like", value, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2In(List<String> values) {
            addCriterion("GUAR_NAME_2 in", values, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2NotIn(List<String> values) {
            addCriterion("GUAR_NAME_2 not in", values, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2Between(String value1, String value2) {
            addCriterion("GUAR_NAME_2 between", value1, value2, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarName2NotBetween(String value1, String value2) {
            addCriterion("GUAR_NAME_2 not between", value1, value2, "guarName2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2IsNull() {
            addCriterion("GUAR_RELATION_2 is null");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2IsNotNull() {
            addCriterion("GUAR_RELATION_2 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2EqualTo(String value) {
            addCriterion("GUAR_RELATION_2 =", value, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2NotEqualTo(String value) {
            addCriterion("GUAR_RELATION_2 <>", value, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2GreaterThan(String value) {
            addCriterion("GUAR_RELATION_2 >", value, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_RELATION_2 >=", value, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2LessThan(String value) {
            addCriterion("GUAR_RELATION_2 <", value, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2LessThanOrEqualTo(String value) {
            addCriterion("GUAR_RELATION_2 <=", value, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2Like(String value) {
            addCriterion("GUAR_RELATION_2 like", value, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2NotLike(String value) {
            addCriterion("GUAR_RELATION_2 not like", value, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2In(List<String> values) {
            addCriterion("GUAR_RELATION_2 in", values, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2NotIn(List<String> values) {
            addCriterion("GUAR_RELATION_2 not in", values, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2Between(String value1, String value2) {
            addCriterion("GUAR_RELATION_2 between", value1, value2, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarRelation2NotBetween(String value1, String value2) {
            addCriterion("GUAR_RELATION_2 not between", value1, value2, "guarRelation2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2IsNull() {
            addCriterion("GUAR_CARD_NO_2 is null");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2IsNotNull() {
            addCriterion("GUAR_CARD_NO_2 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2EqualTo(String value) {
            addCriterion("GUAR_CARD_NO_2 =", value, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2NotEqualTo(String value) {
            addCriterion("GUAR_CARD_NO_2 <>", value, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2GreaterThan(String value) {
            addCriterion("GUAR_CARD_NO_2 >", value, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_CARD_NO_2 >=", value, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2LessThan(String value) {
            addCriterion("GUAR_CARD_NO_2 <", value, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2LessThanOrEqualTo(String value) {
            addCriterion("GUAR_CARD_NO_2 <=", value, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2Like(String value) {
            addCriterion("GUAR_CARD_NO_2 like", value, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2NotLike(String value) {
            addCriterion("GUAR_CARD_NO_2 not like", value, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2In(List<String> values) {
            addCriterion("GUAR_CARD_NO_2 in", values, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2NotIn(List<String> values) {
            addCriterion("GUAR_CARD_NO_2 not in", values, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2Between(String value1, String value2) {
            addCriterion("GUAR_CARD_NO_2 between", value1, value2, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarCardNo2NotBetween(String value1, String value2) {
            addCriterion("GUAR_CARD_NO_2 not between", value1, value2, "guarCardNo2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2IsNull() {
            addCriterion("GUAR_PHONE_2 is null");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2IsNotNull() {
            addCriterion("GUAR_PHONE_2 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2EqualTo(String value) {
            addCriterion("GUAR_PHONE_2 =", value, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2NotEqualTo(String value) {
            addCriterion("GUAR_PHONE_2 <>", value, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2GreaterThan(String value) {
            addCriterion("GUAR_PHONE_2 >", value, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_PHONE_2 >=", value, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2LessThan(String value) {
            addCriterion("GUAR_PHONE_2 <", value, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2LessThanOrEqualTo(String value) {
            addCriterion("GUAR_PHONE_2 <=", value, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2Like(String value) {
            addCriterion("GUAR_PHONE_2 like", value, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2NotLike(String value) {
            addCriterion("GUAR_PHONE_2 not like", value, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2In(List<String> values) {
            addCriterion("GUAR_PHONE_2 in", values, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2NotIn(List<String> values) {
            addCriterion("GUAR_PHONE_2 not in", values, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2Between(String value1, String value2) {
            addCriterion("GUAR_PHONE_2 between", value1, value2, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarPhone2NotBetween(String value1, String value2) {
            addCriterion("GUAR_PHONE_2 not between", value1, value2, "guarPhone2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2IsNull() {
            addCriterion("GUAR_COMPANY_2 is null");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2IsNotNull() {
            addCriterion("GUAR_COMPANY_2 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2EqualTo(String value) {
            addCriterion("GUAR_COMPANY_2 =", value, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2NotEqualTo(String value) {
            addCriterion("GUAR_COMPANY_2 <>", value, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2GreaterThan(String value) {
            addCriterion("GUAR_COMPANY_2 >", value, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_COMPANY_2 >=", value, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2LessThan(String value) {
            addCriterion("GUAR_COMPANY_2 <", value, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2LessThanOrEqualTo(String value) {
            addCriterion("GUAR_COMPANY_2 <=", value, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2Like(String value) {
            addCriterion("GUAR_COMPANY_2 like", value, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2NotLike(String value) {
            addCriterion("GUAR_COMPANY_2 not like", value, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2In(List<String> values) {
            addCriterion("GUAR_COMPANY_2 in", values, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2NotIn(List<String> values) {
            addCriterion("GUAR_COMPANY_2 not in", values, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2Between(String value1, String value2) {
            addCriterion("GUAR_COMPANY_2 between", value1, value2, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarCompany2NotBetween(String value1, String value2) {
            addCriterion("GUAR_COMPANY_2 not between", value1, value2, "guarCompany2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2IsNull() {
            addCriterion("GUAR_JOB_2 is null");
            return (Criteria) this;
        }

        public Criteria andGuarJob2IsNotNull() {
            addCriterion("GUAR_JOB_2 is not null");
            return (Criteria) this;
        }

        public Criteria andGuarJob2EqualTo(String value) {
            addCriterion("GUAR_JOB_2 =", value, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2NotEqualTo(String value) {
            addCriterion("GUAR_JOB_2 <>", value, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2GreaterThan(String value) {
            addCriterion("GUAR_JOB_2 >", value, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2GreaterThanOrEqualTo(String value) {
            addCriterion("GUAR_JOB_2 >=", value, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2LessThan(String value) {
            addCriterion("GUAR_JOB_2 <", value, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2LessThanOrEqualTo(String value) {
            addCriterion("GUAR_JOB_2 <=", value, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2Like(String value) {
            addCriterion("GUAR_JOB_2 like", value, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2NotLike(String value) {
            addCriterion("GUAR_JOB_2 not like", value, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2In(List<String> values) {
            addCriterion("GUAR_JOB_2 in", values, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2NotIn(List<String> values) {
            addCriterion("GUAR_JOB_2 not in", values, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2Between(String value1, String value2) {
            addCriterion("GUAR_JOB_2 between", value1, value2, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andGuarJob2NotBetween(String value1, String value2) {
            addCriterion("GUAR_JOB_2 not between", value1, value2, "guarJob2");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdIsNull() {
            addCriterion("KINDERGARTEN_ID is null");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdIsNotNull() {
            addCriterion("KINDERGARTEN_ID is not null");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdEqualTo(Integer value) {
            addCriterion("KINDERGARTEN_ID =", value, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdNotEqualTo(Integer value) {
            addCriterion("KINDERGARTEN_ID <>", value, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdGreaterThan(Integer value) {
            addCriterion("KINDERGARTEN_ID >", value, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("KINDERGARTEN_ID >=", value, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdLessThan(Integer value) {
            addCriterion("KINDERGARTEN_ID <", value, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdLessThanOrEqualTo(Integer value) {
            addCriterion("KINDERGARTEN_ID <=", value, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdIn(List<Integer> values) {
            addCriterion("KINDERGARTEN_ID in", values, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdNotIn(List<Integer> values) {
            addCriterion("KINDERGARTEN_ID not in", values, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdBetween(Integer value1, Integer value2) {
            addCriterion("KINDERGARTEN_ID between", value1, value2, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andKindergartenIdNotBetween(Integer value1, Integer value2) {
            addCriterion("KINDERGARTEN_ID not between", value1, value2, "kindergartenId");
            return (Criteria) this;
        }

        public Criteria andClassIdIsNull() {
            addCriterion("CLASS_ID is null");
            return (Criteria) this;
        }

        public Criteria andClassIdIsNotNull() {
            addCriterion("CLASS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andClassIdEqualTo(Integer value) {
            addCriterion("CLASS_ID =", value, "classId");
            return (Criteria) this;
        }

        public Criteria andClassIdNotEqualTo(Integer value) {
            addCriterion("CLASS_ID <>", value, "classId");
            return (Criteria) this;
        }

        public Criteria andClassIdGreaterThan(Integer value) {
            addCriterion("CLASS_ID >", value, "classId");
            return (Criteria) this;
        }

        public Criteria andClassIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CLASS_ID >=", value, "classId");
            return (Criteria) this;
        }

        public Criteria andClassIdLessThan(Integer value) {
            addCriterion("CLASS_ID <", value, "classId");
            return (Criteria) this;
        }

        public Criteria andClassIdLessThanOrEqualTo(Integer value) {
            addCriterion("CLASS_ID <=", value, "classId");
            return (Criteria) this;
        }

        public Criteria andClassIdIn(List<Integer> values) {
            addCriterion("CLASS_ID in", values, "classId");
            return (Criteria) this;
        }

        public Criteria andClassIdNotIn(List<Integer> values) {
            addCriterion("CLASS_ID not in", values, "classId");
            return (Criteria) this;
        }

        public Criteria andClassIdBetween(Integer value1, Integer value2) {
            addCriterion("CLASS_ID between", value1, value2, "classId");
            return (Criteria) this;
        }

        public Criteria andClassIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CLASS_ID not between", value1, value2, "classId");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(String value) {
            addCriterion("STATUS like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(String value) {
            addCriterion("STATUS not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<String> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<String> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }
    }

    /**
     * t_student_info
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * t_student_info null
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}